package com.andyage.admin.dao;

import java.util.List;

import com.andyage.admin.bean.AdorderBean;

public interface AdOrderMapper {
	/**
	 * 查询订单表信息
	 * @param order
	 * @return
	 */
	List<AdorderBean> queryAdOrderInfo(AdorderBean order)throws Exception;
	/**
	 * 查询订单数量
	 * @param order
	 * @return
	 */
	int queryAdOrderInfoCount(AdorderBean order)throws Exception;
	/**
	 * 删除未支付订单
	 * @param order
	 * @return
	 */
	int deleteAdOrderInfo(String orderId)throws Exception;
	/**
	 * 修改订单
	 * @param order
	 * @return
	 */
	int updateAdorderInfo(AdorderBean order)throws Exception;
	/**
	 * 查询需要抽奖的所有订单信息
	 * @param order
	 * @return
	 * @throws Exception
	 */
	List<AdorderBean> queryChoujiangOrder(AdorderBean order)throws Exception;
	/**
	 * 查询需要抽奖的所有订单的总数
	 * @param order
	 * @return
	 * @throws Exception
	 */
	int queryChoujiangOrderCount(AdorderBean order)throws Exception;
	/**
	 * 通过时间段查询所有的已支付的支付方式为
	 * 微信（wx）订单总价值
	 * @param order
	 * @return
	 * @throws Exception
	 */
    double queryWxOrderPriceSumByDateTime(AdorderBean order)throws Exception;
    /**
	 * 通过时间段查询所有的已支付的支付方式为
	 * 支付宝（wx）订单总价值
	 * @param order
	 * @return
	 * @throws Exception
	 */
    double queryAliOrderPriceSumByDateTime(AdorderBean order)throws Exception;
    /**
     * 通过时间段查询所有支付的订单的总价值
     * @param order
     * @return
     * @throws Exception
     */
    double queryAllOrderPriceSumByDateTime(AdorderBean order)throws Exception;
}
